Use this query to mass create job numbers: Insert Into [Job] ([DBId], [Id], [Number], [ClientId], [JobTypeId], [DivisionId], [Description], [Actif], [Archive], [JobServiceTRRestriction], [StartDate], [EndDate], [Chargeable], [Status], [TRLockType], [FileHolderEmployeeId], [ReferenceYear], [SupplierBudgetAmount], [JobCategoryId], [StrategyId]) Select [Client].[DBId] as [ResDBId], ROW_NUMBER() OVER(ORDER BY [Client].[Id] ASC) + 13858 AS [ResId], left(case when [Company].[Name] Is Null then [Person].[Name] else [Company].[Name] end,61) + … Continue reading Query to mass create job numbers